Functoid - MakeNull

MakeNull Functoid

Description: The MakeNull Functoid can set Value to NULL in the database, regarding the Condition. Usually a Functoid outputs an empty value in the database. NULL implies that there is no data whatsoever as value. The Condition has 3 options; 0, 1 or an empty string. If the condition is 0 it will output Value, if it's 1 it will always output NULL. When it's an empty string, the Functoid looks at the Value. If that value is empty it will output a NULL, if it's not empty it will output Value. Inputs with their allowed values:

• Value
  • Literal text entered manually
  • Output of another Functoid
  • Value of a Table
• Condition
  • Literal text entered manually
  • Output of another Functoid
  • Value of a Table

Picture of the MakeNull Functoid

Remark: The output of the MakeNull Functoid can not be used as input for another Functoid in the same diagram. Example 1:

• Value
  • This is a string
• Condtion
  • 0
• Output
  • This is a string

See Figure 1.

Figure 1

Example 2:

• Value
  • This is a string
• Condtion
  • 1
• Output
  • Null (The column in ETL will show an empty field, but it's saved as NULL in the database)

See Figure 2.

Figure 2